Java Database Programming with JDBC
by Pratik Patel
Coriolis, The Coriolis Group
ISBN:
1576100561
Pub Date:
10/01/96
Introduction
Chapter 1JDBC: Databases The Java Way!
What Is The JDBC?
The JDBC Structure
ODBCs Part In The JDBC
Summary
Chapter 2SQL 101
The Relational Model And SQL
Understanding The Basics
Putting It Into Perspective: Schema And Catalog
Introducing Keys
Using Multiple Tables And Foreign Keys
Data Definition Language
Declaring Domains
Performing Checks
Creating Tables
Manipulating Tables
Data Maintenance Language
Data Query Language
Coming Up Next
Chapter 3Using JDBC Drivers
Quick Start Guide
Installing java.sql.*
Registering And Calling JDBC Drivers
The sql.drivers Property
Theres Always A Class For A Name
Just Do It
JDBC URL And The Connection
Using ODBC Drivers
Installing The JDBC-ODBC Bridge
Setting Up ODBC Drivers
Summary
Chapter 4The InteractiveSQL Applet
Your First JDBC Applet
The Blueprint
Getting A Handle On The JDBC Essentials: The Complete Applet Source Code
The Look Of The Applet
Handling Events
Opening The Connection
No Guts, No Glory: Executing Queries And Processing Results
Wrapping It Up
The HTML File That Calls The Applet
The Final Product
Coming Up Next
Chapter 5Accessing ODBC Services Using JDBC
Bridge Requirements
The Bridge Is Great, But...
The ODBC URL
JDBC To ODBC Calls: A Roadmap
Chapter 6SQL Data Types In Java And ORM
Mapping SQL Data To Java
ResultSetMetaData
Understanding The Object Relation Model
Mapping A Table Into A Java Object
Summary
Chapter 7Working With Query Results
A Basic Java Object For Storing Results
Showing The Results
Charting Your Data
Summary
Chapter 8The IconStore Multimedia JDBC Application
IconStore Requirements
Building The Database
Application Essentials
Writing The main Method
Establishing The Database Connection
Creating The Menu
Creating The Lists
Handling Events
Saving The Image
Summary
Chapter 9Java And Database Security
Database Server Security
Rooting Out The Packet Sniffers
Web Server CGI Holes
Finding A Solution
Applet Security: Can I Trust You?
The Applet Security Manager
Im A Certified Applet
Summary
Chapter 10Writing Database Drivers
The JDBC Driver Project: SimpleText
SimpleText SQL Grammar
SimpleText File Format
The DriverManager
JDBC Exception Types
JDBC Data Types
Character Data: CHAR, VARCHAR, And LONGVARCHAR
Exact Numeric Data: NUMERIC And DECIMAL
Binary Data: BINARY, VARBINARY, And LONGVARBINARY
Boolean Data: BIT
Integer Data: TINYINT, SMALLINT, INTEGER, And BIGINT
Floating-Point Data: REAL, FLOAT, And DOUBLE
Time Data: DATE, TIME, And TIMESTAMP
New Data Classes
Numeric
Date
Time
Timestamp
Native Drivers: Youre Not From Around Here, Are Ya?
Implementing Interfaces
Tracing
Turning On Tracing
Writing Tracing Information
Checking For Tracing
Data Coercion
Escape Clauses
Date, Time, And Timestamp
Scalar Functions
LIKE Predicate Escape Characters
Outer Joins
Procedures
The JDBC Interfaces
Driver
Connection
DatabaseMetaData
Statement
PreparedStatement
ResultSet
ResultSetMetaData
Summary
Chapter 11Internet Database Issues: Middleware
Connectivity Issues Involved With Database Access
Advantages Of Middleware
Disadvantages Of Middleware
The Application Server: A Complete Example With Code
The Client: A Complete Example With Code
Summary
Chapter 12The JDBC API
Classes
public class Date
public class DriverManager
public class DriverPropertyInfo
public final class Numeric
public class Time
public class TimeStamp
public class Types
Interfaces
public interface CallableStatement
public interface Connection
public interface DatabaseMetaData
public interface Driver
public interface PreparedStatement
public interface ResultSet
public interface ResultSetMetaData
public interface Statement
Exceptions
public class DataTruncation
public class SQLException
public class SQLWarning
Appendix A
Appendix B
Appendix C
Appendix D
Index